UCSF

Parameters Provided:

name.synonym = 1-amino-propane-1,3-dicarboxylic acid; 2-aminopentanedioic acid; 56-86-0; L-glu; L-glutamate; L-glutamic acid; alpha-aminoglutaric acid; glt; glu; glut; glutacid; glutamate; glutaminic acid
filter.purchasability = all
VisitorId = 7c718092-f5b9-4c47-a3be-b5957d2f3cc0
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-amino-propane-1,3-dicarboxylic acid; 2-aminopentanedioic acid; 56-86-0; L-glu; L-glutamate; L-glutamic acid; alpha-aminoglutaric acid; glt; glu; glut; glutacid; glutamate; glutaminic acid' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-amino-propane-1%2C3-dicarboxylic+acid%3B+2-aminopentanedioic+acid%3B+56-86-0%3B+L-glu%3B+L-glutamate%3B+L-glutamic+acid%3B+alpha-aminoglutaric+acid%3B+glt%3B+glu%3B+glut%3B+glutacid%3B+glutamate%3B+glutaminic+acid&filter.purchasability=all

Embed Link to Results